package com.example.ujsfish.database;

import androidx.room.Dao;
import androidx.room.Delete;
import androidx.room.Insert;
import androidx.room.Query;
import androidx.room.Update;

import java.util.List;
@Dao
public interface PoolDao {
    @Insert
    void insertPools(Pool... pools);

    @Update
    void updatePools(Pool... pools);

    @Delete
    void deletePools(Pool... pools);

    @Query("DELETE FROM Pool")
    void deleteAllPools();

    @Query("SELECT * FROM Pool ORDER BY pool_id DESC")
    List<Pool> getAllPools();
}
